/*
 Navicat MySQL Data Transfer

 Source Server         : mysql
 Source Server Version : 50611
 Source Host           : localhost
 Source Database       : sss

 Target Server Version : 50611
 File Encoding         : utf-8

 Date: 12/14/2014 20:09:22 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_operateLog`
-- ----------------------------
DROP TABLE IF EXISTS `t_operateLog`;
CREATE TABLE `t_operateLog` (
  `author` varchar(50) NOT NULL,
  `operateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operateType` varchar(100) NOT NULL,
  `operateDesc` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_operateLog`
-- ----------------------------
BEGIN;
INSERT INTO `t_operateLog` VALUES ('nobody', '2014-12-14 00:58:53', '1', 'requestURL', 'request /user'), ('nobody', '2014-12-14 00:58:53', '2', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 01:00:06', '3', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 01:00:06', '4', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 01:02:55', '5', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 01:03:09', '6', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 01:04:33', '7', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 01:04:39', '8', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 01:07:07', '9', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 01:07:13', '10', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 01:10:28', '11', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 01:10:55', '12', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 01:20:42', '13', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 10:01:30', '14', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 10:01:39', '15', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 10:01:39', '16', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 10:01:40', '17', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 10:01:41', '18', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 10:17:50', '19', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 10:17:51', '20', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 10:17:52', '21', 'requestURL', 'request /user/allusers'), ('Tommy@sina.com', '2014-12-14 10:17:58', '22', 'requestURL', 'request /user/allusers'), ('Tommy@sina.com', '2014-12-14 10:19:42', '23', 'requestURL', 'request /user/allusers'), ('Tommy@sina.com', '2014-12-14 11:42:07', '24', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 11:42:08', '25', 'requestURL', 'request /userContainer'), ('Tommy@sina.com', '2014-12-14 11:55:19', '26', 'requestURL', 'request /user/allusers'), ('Tommy@sina.com', '2014-12-14 12:21:03', '27', 'requestURL', 'request /user'), ('Tommy@sina.com', '2014-12-14 12:21:04', '28', 'jquery ajax get', 'request home/userData'), ('Tommy@sina.com', '2014-12-14 15:01:39', '29', 'requestURL', 'request home/user'), ('Tommy@sina.com', '2014-12-14 15:01:39', '30', 'jquery ajax get', 'request home/userData'), ('Tommy@sina.com', '2014-12-14 16:57:07', '31', 'requestURL', 'request home/user'), ('Tommy@sina.com', '2014-12-14 17:28:06', '32', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:28:06', '33', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:28:09', '34', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:28:09', '35', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:30:03', '36', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:30:03', '37', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:31:10', '38', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:31:15', '39', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:31:16', '40', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:31:20', '41', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:32:28', '42', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:32:30', '43', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:32:31', '44', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:32:37', '45', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:43:51', '46', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:45:29', '47', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:54:15', '48', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:54:17', '49', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:54:18', '50', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:54:22', '51', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:54:58', '52', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:56:47', '53', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:58:22', '54', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:59:10', '55', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:59:11', '56', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:59:14', '57', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:59:14', '58', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:59:14', '59', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 17:59:35', '60', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:00:33', '61', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:00:48', '62', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:00:50', '63', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:00:51', '64', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:00:51', '65', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:05:13', '66', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:05:17', '67', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:06:23', '68', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:13:42', '69', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:13:44', '70', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:13:45', '71', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:17:55', '72', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:17:55', '73', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:20:15', '74', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:29:50', '75', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:30:08', '76', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:30:09', '77', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:31:16', '78', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:37:24', '79', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:37:27', '80', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:41:49', '81', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:42:45', '82', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:44:18', '83', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:44:34', '84', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:44:44', '85', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:46:59', '86', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:49:32', '87', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:53:49', '88', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:53:51', '89', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:54:08', '90', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:54:48', '91', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:55:41', '92', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 18:59:10', '93', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:01:29', '94', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:02:34', '95', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:03:41', '96', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:05:42', '97', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:06:03', '98', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:07:56', '99', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:08:26', '100', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:10:01', '101', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:10:06', '102', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:10:10', '103', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:44:23', '104', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:45:09', '105', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:45:12', '106', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:45:14', '107', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:49:37', '108', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:54:50', '109', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:55:26', '110', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:55:43', '111', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:56:06', '112', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:56:12', '113', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:58:31', '114', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:58:32', '115', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:58:34', '116', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:59:08', '117', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:59:10', '118', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 19:59:39', '119', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:01:22', '120', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:01:23', '121', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:03:13', '122', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:03:14', '123', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:03:15', '124', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:03:16', '125', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:03:29', '126', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:05:27', '127', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:05:47', '128', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:08:07', '129', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:08:09', '130', 'requestURL', 'request /user/changelang'), ('Tommy@sina.com', '2014-12-14 20:08:10', '131', 'requestURL', 'request /user/changelang');
COMMIT;

-- ----------------------------
--  Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `role` varchar(10) NOT NULL,
  `mail` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mail` (`mail`),
  CONSTRAINT `role_fk` FOREIGN KEY (`mail`) REFERENCES `t_user` (`mail`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_role`
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES ('1', 'admin', 'tim@sina.com'), ('2', 'user', 'mike@sina.com');
COMMIT;

-- ----------------------------
--  Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `mail` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mail` (`mail`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_user`
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('tim@sina.com', 'aaaa', '0', 'Tim Jack'), ('mike@sina.com', 'bbb', '1', 'Ellen');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
